From 2aab604c44ce1b24373dc082c6c52590011956f1 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Thu, 23 Jul 2026 21:19:45 +0000 Subject: [PATCH] Fix BRECORD_NOTES columns to allow empty strings Credit to Steve Daniels of Ode for finding the problem. --- .../sokwedb/tables/create/brecord_notes.m4 | 16 ++++++++-------- 1 file changed, 8 insertions(+), 8 deletions(-) diff --git a/db/schemas/sokwedb/tables/create/brecord_notes.m4 b/db/schemas/sokwedb/tables/create/brecord_notes.m4 index 7a1aed3..99458f0 100644 --- a/db/schemas/sokwedb/tables/create/brecord_notes.m4 +++ b/db/schemas/sokwedb/tables/create/brecord_notes.m4 @@ -30,21 +30,21 @@ CREATE TABLE brecord_notes ( notonlyspaces_check(`Observation') trimmedofspaces_check(`Observation') ,comments TEXT NOT NULL - emptytext_check(`Comments') + notonlyspaces_check(`Comments') ,observer TEXT NOT NULL - emptytext_check(`Observer') + notonlyspaces_check(`Observer') ,translator TEXT NOT NULL - emptytext_check(`Translator') + notonlyspaces_check(`Translator') ,transcribedby TEXT NOT NULL - emptytext_check(`TranscribedBy') + notonlyspaces_check(`TranscribedBy') ,voc TEXT NOT NULL - emptytext_check(`Voc') + notonlyspaces_check(`Voc') ,vocid TEXT NOT NULL - emptytext_check(`VocID') + notonlyspaces_check(`VocID') ,groomingaggression TEXT NOT NULL - emptytext_check(`GroomingAggression') + notonlyspaces_check(`GroomingAggression') ,duplicate TEXT NOT NULL - emptytext_check(`Duplicate') + notonlyspaces_check(`Duplicate') ); eid_primary_key(`BRECORD_NOTES') -- 2.34.1